Excel variable name	New name	Label 	Detail info	Coding	To do/Comments
id				participant number.city.treatment.subtreatment	For participants 1-9 create a 0 before constructing the id
date					
start					
end					
district	city	Location of school		1=Andapa, 2=Sambava, 3=Antalaha, 4=Vohemar	label accordingly and label define
player					
group		Group number	in each group 4 participants (or less)		
id_group		Unique identifier for the group		id_group= string(group) + string(city) +string(treatment)+string(session)	
name		Name			
treat_video		Treatment 		1= woman video, 2= man video, 0 = control 	label define
treat_job		Subtreatment		1= public, 2=private	label define
session		Session number		1= morning session, 2=afternoon session	label define
social_decision	take_advantage	Take advantage		"First recode it:
1=9, 1=0 
Then define label:
1=take advantage, 0= does not take advantage"	change accordingly
luck_result	luck	Luck in game		"First recode it:
1=Y, 0=B
Then define label:
1=good luck, 0= bad luck"	change accordingly
know_character		Participant knows character	Do you know the person in the video?	Yes=1, No=0	label define
relation_character		Participant's relation to character	On a scale from 1 to 5, where 1 is not close at all and 5 is very close, how you rate the relationship you have with the main character[s] shown in the video?	1=not close at all, 2=not close, 3=neutral, 4=close, 5=very close	label define
motivated_character	motivated_video	Participant's motivation after video	�I feel motivated by the video I have just seen�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
like_character		Participant likes character	�I like the main character(s) of the video�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
identify_character		Participant identifies with character	�I can identify with the main character(s) of the video�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
success_character		Participant thinks character is successful 	�The main character(s) of the video is successful in his/her life�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
risk_character		Participant thinks character is not afraid of risks	The main character(s) of the video is a person who is not afraid of taking risks.�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
future_character 		Participant thinks he can be as successful as character	�I think I can be as successful as the main character(s) of the video within the next ten years.�	1=strongly disagree, 2=disagree, 3=neither agree nor disagree, 4=agree, 5=strongly agree	label define
education_max		Maximum education years in city or village	What is the maximum level of education an average person in the city or village that you come from can have? 	"0=No education, 
1=T1
2=T2
3=T3
4=T4
5=T5, 
5.5=CEPE, 
6=6eme, 
7=5eme, 
8=4eme, 
9=3eme, 
9.5 =BEPC
10=2nde, 
11=1ere, 
12=Terminal, 
12.5=BAC, 
16=Licence, 
18=Master, 
22=Doctorate"	"change accordingly 

BAC+2 = 14 (terminal + 2)
BAC+4 = 16 (terminal + 4)
BAC+5 = 17 (terminal +5)
MASTER2 = 18

[Note for us: 
Numbers try to coincide with years of studying. 
After T5 is completed person achieves the CEPE (Certificat d�etudes primaires �l�mentaires). Therefore, all people with equal or more education years than T6 are considered to have the CEPE. Same with the BEPC (Brevet d'Etudes du Premier Cycle) which is achieved once 3eme is complete.  All people with more or equal level as 2eme are considered to have the BEPC]
Children must take an exam at the end of primary school to obtain their certificate of Primary School (CEPE), students who do not pass cannot progress to secondary school. Secondary school is a seven-year program that is further divided into two levels: junior secondary school and senior secondary school. Junior secondary school takes four years and students who graduate are awarded a certificate (BEPC). Senior secondary school is another three years after which graduating students are awarded their �baccalaureate�, a degree that is equivalent to a high school diploma in the United States.
[Scale based on conversation with enumerator in the field: 
Profesional = Licence
BAC+3-4 = Licence
BAC+5-7 = Master2
BAC+8...20 = Doctorate]
"
education_min		Minimum education years in city or village	What is the minimum level of education that an average person in the city or village that you come from can have? 	"0=No education, 
1=T1
2=T2
3=T3
3.5=BEPC
4=T4
5=T5, 
5.5=CEPE, 
6=6eme, 
7=5eme, 
8=4eme, 
9=3eme, 
10=2nde, 
11=1ere, 
12=Terminal, 
12.5=BAC, 
16=Licence, 
18=Master, 
22=Doctorate"	"change accordingly

EPP = CEPE = 5.5
T10 = 1ere = 11 
T6= 6eme = 6
T7= 5eme = 7 
T8= 4eme = 8
T9=3eme = 9 
"
education_achieved		Years of education present	What is the education level that you have achieved until now	"0=No education, 
1=T1
2=T2
3=T3
3.5=BEPC
4=T4
5=T5, 
5.5=CEPE, 
6=6eme, 
7=5eme, 
8=4eme, 
9=3eme, 
10=2nde, 
11=1ere, 
12=Terminal, 
12.5=BAC, 
16=Licence, 
18=Master, 
22=Doctorate"	"change accordingly 

BAC+3 = 15 (terminal +3)
"
education_goal		Years of education desired	What is the level of education you would like to achieve in your life? (goal/desire) 	"0=No education, 
1=T1
2=T2
3=T3
3.5=BEPC
4=T4
5=T5, 
5.5=CEPE, 
6=6eme, 
7=5eme, 
8=4eme, 
9=3eme, 
10=2nde, 
11=1ere, 
12=Terminal, 
12.5=BAC, 
16=Licence, 
18=Master, 
22=Doctorate"	"change accordingly

BAC+1 = 13 (terminal + 1)
BAC+10 = 22 (terminal + 10)
�
Master2=Master=18
Professional=Licence=16
Professor=Doctorate=22
Prison guardian=Terminal=12
"
education_exp 		Years of education expected	What is the level of education you expect to achieve in your life? (what you will probably achieve) 	"0=No education, 
1=T1
2=T2
3=T3
3.5=BEPC
4=T4
5=T5, 
5.5=CEPE, 
6=6eme, 
7=5eme, 
8=4eme, 
9=3eme, 
10=2nde, 
11=1ere, 
12=Terminal, 
12.5=BAC, 
16=Licence, 
18=Master, 
22=Doctorate"	"change accordingly

6 taona = 6 years = 6
8 taona = 8 years = 8
BAC+
�
Expertise = Doctorate = 22 
Master2/Master1=Master=18
Professional=Licence=16
Professor=Doctorate=22
"
income_max		Maximum Income per month in city or village (Ariary)	What is the maximum level of average income per month that an average person in the city or village that you come from can have?  	Open numeric	
income_min		Minimum Income per month in city or village (Ariary)	What is the minimum level of average income per month that an average person in the city or village that you come from can have? 	Open numeric	
income_achieved		Income per month at present (Ariary)	What is your average income per month at the present? 	Open numeric	
income_goal		Income per month desired (Ariary)	What is the level of average income per month you would like to achieve in your life? (goal/desire) 	Open numeric	
income_exp		Income per month expected (Ariary)	What is the level of average income per month you expect to achieve in your life? (what you will probably achieve) 	Open numeric	
status_max		Maximum social status in city or village 	What is the maximum level of social status that an average person in the city or village that you come from can have? 	Values from 0-10	
status_min		Minimum social status in city or village 	What is the minimum level of social status that an average person in the city or village that you come from can have? 	Values from 0-10	
status_achieved		Social status at present	What is the level of your social status at present? 	Values from 0-10	
status_goal		Social status desired	What is the level of social status you would like to achieve in your life? (goal/desire) 	Values from 0-10	
status_exp		Social status expected	What is the level of social status you expect to achieve in your life? (what you will probably achieve) 	Values from 0-10	
asset_max		Maximum level of assets in city or village (Ariary)	What is the maximum level of assets (house and furniture, no other assets) an average person in the city or village that you come from can have? 	Open numeric	
asset_min		Minimum level of assets in city or village (Ariary)	What is the minimum level of assets (house and furniture, no other assets) that an average person in the city or village that you come from can have? 	Open numeric	
asset_achieved		Present level of assets	What is the level of assets (house and furniture, no other assets) you have at present? 	Open numeric	
asset_goal		Level of assets desired	What is the level of assets (house and furniture, no other assets) you would like to achieve in your life? (goal/desire)	Open numeric	
asset_exp		Level of assets expected	e) What is the level of assets (house and furniture, no other assets) you expect to achieve in your life? (what you will probably achieve)	Open numeric	
weight_edu		Weight education		Open numeric	
weight_inc		Weight income		Open numeric	
weight_social		Weight social		Open numeric	
weight_assets		Weight assets		Open numeric	
total_weight		Total weight		Value = 20	weight those who are less or more than 20 and adjust
ptask_1		Performance task 1		Values from 0-10	
answered_1		Number of answers task 1 		Values from 0-10	
belief_1		Belief performance task 1		Values from 0-10	
ptask_2		Performance task 2		Values from 0-10	
answered_2		Number of answers task 2		Values from 0-10	
belief_2		Belief performance task 2		Values from 0-10	
winner_2		Winner task 2		winner = 1, loser=0 	label define
ptask_3		Performance task 3		Values from 0-10	
decision_3		Decision to compete task 3		"1=C , 0=NC
1= compete, 0= no compete"	label define
answered_3		Number of answers task 3		Values from 0-10	
belief_3		Belief performance task 3		Values from 0-10	
winner_3		Winner task 3		winner = 1, loser=0 	label define
decision_4		Decision to compete task 4		"1=C , 0=NC
1= compete, 0= no compete"	label define
winner_4		Winner task 4		winner = 1, loser=0 	label define
ptask_5		Performance task 5		Values from 0-10	
decision_5		Decision to compete task 5		"1=C , 0=NC
1= compete, 0= no compete"	label define
answered_5		Number of answers task 5		Values from 0-10	
belief_5		Belief performance task 5		Values from 0-10	
winner_5		Winner task 5		winner = 1, loser=0 	label define
belief_rank_1		Belief Rank task 1		Values from 1-4	
rank_1		Rank task 1		Values from 1-4	
belief_rank_2		Belief Rank task 2		Values from 1-4	
rank_2		Rank task 2		Values from 1-4	
belief_pothers		Belief average performance others		Values from 0-10	
pothers		Average performance others		Values from 0-10	
belief_compete		Belief decision to compete others task 3		Values from 0-3	
number_compete		Decision to compete others task 3		Values from 0-3	
earnings_activity		Payment received			
interest_job		Job interest		Yes=1, No=0	label define
position_job		Position of interest		Coordinator=1, Assistant=0	label define
gender	female	Female 		Female = 1, Male=0	label define
complete_app		Complete application		Yes=1, No=0	label define
av_grade	grade_app	Average grade application		Values from 1 (min) to 20 (max)	
grade1		Grade trimestre 1		Values from 1 (min) to 20 (max)	add to excel file
grade2		Grade trimestre 2		Values from 1 (min) to 20 (max)	add to excel file
grade3		Grade trimestre 3		Values from 1 (min) to 20 (max)	add to excel file
level		Level of studies		A1=1, A2=2, C=3, D=4	Levels A1 and A2 focus in science while C and D focus on languages
	science_focus	Science focus		A1=1, A2=0	create from variable level of studies
	language_focus	Language focus		C=1, D=0	create from variable level of studies
english_level		English level		1=not good, 2=so so , 3=good, 4=very good 	label define
french_level		French level		1=not good, 2=so so , 3=good, 4=very good 	label define
knowledge_project		Knowledge project		Yes=1, No=0	label define
expect_salary		Salary expectation		Open numeric	
work_experience		Work experience		Yes=1, No=0	label define